package com.kcsj.demo.Mapper;

import com.kcsj.demo.Module.Main;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ListMapper {
    @Insert("insert into main(user_name,supplier_name,commodity_name,commodity_number,gmt_create) values(#{userName},#{supplierName},#{commodityName},#{commodityNumber},#{gmtCreate})")
    public void insert(Main main);

    @Select("select * from main")
    List<Main> list();

    @Delete("delete from main where user_name=#{userName}")
    public void delete(String name);
}
